{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from glob import glob\n",
    "from IPython.display import display\n",
    "pd.set_option('display.max_columns', 99)\n",
    "pd.set_option('display.max_rows', 99)\n",
    "import EDA\n",
    "import utils\n",
    "#sorted(glob('../data/*'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 20/20 [00:06<00:00,  2.91it/s]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SK_ID_PREV</th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>MONTHS_BALANCE</th>\n",
       "      <th>AMT_BALANCE</th>\n",
       "      <th>AMT_CREDIT_LIMIT_ACTUAL</th>\n",
       "      <th>AMT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_POS_CURRENT</th>\n",
       "      <th>AMT_INST_MIN_REGULARITY</th>\n",
       "      <th>AMT_PAYMENT_CURRENT</th>\n",
       "      <th>AMT_PAYMENT_TOTAL_CURRENT</th>\n",
       "      <th>AMT_RECEIVABLE_PRINCIPAL</th>\n",
       "      <th>AMT_RECIVABLE</th>\n",
       "      <th>AMT_TOTAL_RECEIVABLE</th>\n",
       "      <th>CNT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_POS_CURRENT</th>\n",
       "      <th>CNT_INSTALMENT_MATURE_CUM</th>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <th>SK_DPD</th>\n",
       "      <th>SK_DPD_DEF</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>584804</th>\n",
       "      <td>1489396</td>\n",
       "      <td>100006</td>\n",
       "      <td>-1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>270000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520387</th>\n",
       "      <td>1489396</td>\n",
       "      <td>100006</td>\n",
       "      <td>-2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>270000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1347528</th>\n",
       "      <td>1489396</td>\n",
       "      <td>100006</td>\n",
       "      <td>-3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>270000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1399895</th>\n",
       "      <td>1489396</td>\n",
       "      <td>100006</td>\n",
       "      <td>-4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>270000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655566</th>\n",
       "      <td>1489396</td>\n",
       "      <td>100006</td>\n",
       "      <td>-5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>270000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         SK_ID_PREV  SK_ID_CURR  MONTHS_BALANCE  AMT_BALANCE  \\\n",
       "584804      1489396      100006              -1          0.0   \n",
       "520387      1489396      100006              -2          0.0   \n",
       "1347528     1489396      100006              -3          0.0   \n",
       "1399895     1489396      100006              -4          0.0   \n",
       "655566      1489396      100006              -5          0.0   \n",
       "\n",
       "         AMT_CREDIT_LIMIT_ACTUAL  AMT_DRAWINGS_ATM_CURRENT  \\\n",
       "584804                    270000                       NaN   \n",
       "520387                    270000                       NaN   \n",
       "1347528                   270000                       NaN   \n",
       "1399895                   270000                       NaN   \n",
       "655566                    270000                       NaN   \n",
       "\n",
       "         AMT_DRAWINGS_CURRENT  AMT_DRAWINGS_OTHER_CURRENT  \\\n",
       "584804                    0.0                         NaN   \n",
       "520387                    0.0                         NaN   \n",
       "1347528                   0.0                         NaN   \n",
       "1399895                   0.0                         NaN   \n",
       "655566                    0.0                         NaN   \n",
       "\n",
       "         AMT_DRAWINGS_POS_CURRENT  AMT_INST_MIN_REGULARITY  \\\n",
       "584804                        NaN                      0.0   \n",
       "520387                        NaN                      0.0   \n",
       "1347528                       NaN                      0.0   \n",
       "1399895                       NaN                      0.0   \n",
       "655566                        NaN                      0.0   \n",
       "\n",
       "         AMT_PAYMENT_CURRENT  AMT_PAYMENT_TOTAL_CURRENT  \\\n",
       "584804                   NaN                        0.0   \n",
       "520387                   NaN                        0.0   \n",
       "1347528                  NaN                        0.0   \n",
       "1399895                  NaN                        0.0   \n",
       "655566                   NaN                        0.0   \n",
       "\n",
       "         AMT_RECEIVABLE_PRINCIPAL  AMT_RECIVABLE  AMT_TOTAL_RECEIVABLE  \\\n",
       "584804                        0.0            0.0                   0.0   \n",
       "520387                        0.0            0.0                   0.0   \n",
       "1347528                       0.0            0.0                   0.0   \n",
       "1399895                       0.0            0.0                   0.0   \n",
       "655566                        0.0            0.0                   0.0   \n",
       "\n",
       "         CNT_DRAWINGS_ATM_CURRENT  CNT_DRAWINGS_CURRENT  \\\n",
       "584804                        NaN                     0   \n",
       "520387                        NaN                     0   \n",
       "1347528                       NaN                     0   \n",
       "1399895                       NaN                     0   \n",
       "655566                        NaN                     0   \n",
       "\n",
       "         CNT_DRAWINGS_OTHER_CURRENT  CNT_DRAWINGS_POS_CURRENT  \\\n",
       "584804                          NaN                       NaN   \n",
       "520387                          NaN                       NaN   \n",
       "1347528                         NaN                       NaN   \n",
       "1399895                         NaN                       NaN   \n",
       "655566                          NaN                       NaN   \n",
       "\n",
       "         CNT_INSTALMENT_MATURE_CUM NAME_CONTRACT_STATUS  SK_DPD  SK_DPD_DEF  \n",
       "584804                         0.0               Active       0           0  \n",
       "520387                         0.0               Active       0           0  \n",
       "1347528                        0.0               Active       0           0  \n",
       "1399895                        0.0               Active       0           0  \n",
       "655566                         0.0               Active       0           0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = utils.read_pickles('../data/credit_card_balance').sort_values(['SK_ID_CURR', 'MONTHS_BALANCE'], ascending=[True, False])\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape: (3840312, 23)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DataType</th>\n",
       "      <th>#Nulls</th>\n",
       "      <th>#Uniques</th>\n",
       "      <th>Min</th>\n",
       "      <th>Mean</th>\n",
       "      <th>Max</th>\n",
       "      <th>Std</th>\n",
       "      <th>top10 val</th>\n",
       "      <th>top10 cnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SK_ID_PREV</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>104307</td>\n",
       "      <td>1000018.000</td>\n",
       "      <td>1.904504e+06</td>\n",
       "      <td>2843496.000</td>\n",
       "      <td>536469.470563</td>\n",
       "      <td>[1009171, 1348858, 1745395, 2526035, 1567893, ...</td>\n",
       "      <td>[96, 96, 96, 96, 96, 96, 96, 96, 96, 96]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>103558</td>\n",
       "      <td>100006.000</td>\n",
       "      <td>2.783242e+05</td>\n",
       "      <td>456250.000</td>\n",
       "      <td>102704.475133</td>\n",
       "      <td>[186401, 311118, 120076, 128827, 246089, 19182...</td>\n",
       "      <td>[192, 178, 140, 129, 128, 128, 128, 127, 127, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MONTHS_BALANCE</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "      <td>-96.000</td>\n",
       "      <td>-3.452192e+01</td>\n",
       "      <td>-1.000</td>\n",
       "      <td>26.667751</td>\n",
       "      <td>[-4, -5, -3, -6, -7, -2, -8, -9, -10, -11]</td>\n",
       "      <td>[102115, 100546, 100355, 98577, 95332, 94643, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_BALANCE</th>\n",
       "      <td>float64</td>\n",
       "      <td>0</td>\n",
       "      <td>1347904</td>\n",
       "      <td>-420250.185</td>\n",
       "      <td>5.830016e+04</td>\n",
       "      <td>1505902.185</td>\n",
       "      <td>106307.031025</td>\n",
       "      <td>[0.0, 67.5, 130.5, 270.0, 135.0, 202.5, 450.0,...</td>\n",
       "      <td>[2156420, 16049, 3662, 2313, 921, 742, 536, 31...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_LIMIT_ACTUAL</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>181</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.538080e+05</td>\n",
       "      <td>1350000.000</td>\n",
       "      <td>165145.699523</td>\n",
       "      <td>[0, 180000, 135000, 45000, 90000, 67500, 45000...</td>\n",
       "      <td>[753823, 529292, 430142, 329932, 319996, 30886...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>749816</td>\n",
       "      <td>2267</td>\n",
       "      <td>-6827.310</td>\n",
       "      <td>5.961325e+03</td>\n",
       "      <td>2115000.000</td>\n",
       "      <td>28225.688579</td>\n",
       "      <td>[0.0, 4500.0, 9000.0, 45000.0, 2250.0, 22500.0...</td>\n",
       "      <td>[2665718, 35851, 27726, 22946, 22854, 22676, 2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_DRAWINGS_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>0</td>\n",
       "      <td>187005</td>\n",
       "      <td>-6211.620</td>\n",
       "      <td>7.433388e+03</td>\n",
       "      <td>2287098.315</td>\n",
       "      <td>33846.077334</td>\n",
       "      <td>[0.0, 4500.0, 9000.0, 2250.0, 45000.0, 22500.0...</td>\n",
       "      <td>[3223443, 30257, 22968, 20212, 18947, 18670, 1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>749816</td>\n",
       "      <td>1832</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2.881696e+02</td>\n",
       "      <td>1529847.000</td>\n",
       "      <td>8201.989345</td>\n",
       "      <td>[0.0, 3343.5, 6682.5, 4455.0, 8910.0, 46800.0,...</td>\n",
       "      <td>[3078163, 782, 460, 441, 319, 242, 235, 216, 2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_DRAWINGS_POS_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>749816</td>\n",
       "      <td>168748</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2.968805e+03</td>\n",
       "      <td>2239274.160</td>\n",
       "      <td>20796.887047</td>\n",
       "      <td>[0.0, 450.0, 900.0, 2250.0, 4500.0, 1350.0, 22...</td>\n",
       "      <td>[2825595, 1287, 976, 910, 801, 784, 609, 462, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_INST_MIN_REGULARITY</th>\n",
       "      <td>float64</td>\n",
       "      <td>305236</td>\n",
       "      <td>312266</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.540204e+03</td>\n",
       "      <td>202882.005</td>\n",
       "      <td>5600.154122</td>\n",
       "      <td>[0.0, 9000.0, 6750.0, 3375.0, 4500.0, 2250.0, ...</td>\n",
       "      <td>[1928864, 225429, 147469, 127613, 124979, 1083...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_PAYMENT_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>767988</td>\n",
       "      <td>163209</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.028054e+04</td>\n",
       "      <td>4289207.445</td>\n",
       "      <td>36078.084953</td>\n",
       "      <td>[0.0, 9000.0, 4500.0, 6750.0, 13500.0, 22500.0...</td>\n",
       "      <td>[390507, 257297, 143572, 128296, 100454, 56016...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_PAYMENT_TOTAL_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>0</td>\n",
       "      <td>182957</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.588857e+03</td>\n",
       "      <td>4278315.690</td>\n",
       "      <td>32005.987768</td>\n",
       "      <td>[0.0, 9000.0, 4500.0, 6750.0, 13500.0, 22500.0...</td>\n",
       "      <td>[2172223, 250826, 139736, 126483, 94005, 49059...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_RECEIVABLE_PRINCIPAL</th>\n",
       "      <td>float64</td>\n",
       "      <td>0</td>\n",
       "      <td>1195839</td>\n",
       "      <td>-423305.820</td>\n",
       "      <td>5.596588e+04</td>\n",
       "      <td>1472316.795</td>\n",
       "      <td>102533.616843</td>\n",
       "      <td>[0.0, 45000.0, 90000.0, 135000.0, 67500.0, 180...</td>\n",
       "      <td>[2296167, 5072, 4767, 4513, 3537, 3256, 2034, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_RECIVABLE</th>\n",
       "      <td>float64</td>\n",
       "      <td>0</td>\n",
       "      <td>1338878</td>\n",
       "      <td>-420250.185</td>\n",
       "      <td>5.808881e+04</td>\n",
       "      <td>1493338.185</td>\n",
       "      <td>105965.369908</td>\n",
       "      <td>[0.0, 67.5, 270.0, 130.5, 135.0, 202.5, 45000....</td>\n",
       "      <td>[2113816, 3144, 2301, 825, 756, 699, 645, 310,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_TOTAL_RECEIVABLE</th>\n",
       "      <td>float64</td>\n",
       "      <td>0</td>\n",
       "      <td>1339008</td>\n",
       "      <td>-420250.185</td>\n",
       "      <td>5.809829e+04</td>\n",
       "      <td>1493338.185</td>\n",
       "      <td>105971.801103</td>\n",
       "      <td>[0.0, 67.5, 270.0, 130.5, 135.0, 202.5, 45000....</td>\n",
       "      <td>[2113643, 3144, 2301, 825, 756, 699, 645, 310,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CNT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>749816</td>\n",
       "      <td>44</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.094490e-01</td>\n",
       "      <td>51.000</td>\n",
       "      <td>1.100401</td>\n",
       "      <td>[0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, ...</td>\n",
       "      <td>[2665718, 213460, 95647, 46730, 26335, 14910, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CNT_DRAWINGS_CURRENT</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>129</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.031439e-01</td>\n",
       "      <td>165.000</td>\n",
       "      <td>3.190347</td>\n",
       "      <td>[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]</td>\n",
       "      <td>[3229952, 231319, 116762, 65318, 43290, 28987,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CNT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>749816</td>\n",
       "      <td>11</td>\n",
       "      <td>0.000</td>\n",
       "      <td>4.812496e-03</td>\n",
       "      <td>12.000</td>\n",
       "      <td>0.082639</td>\n",
       "      <td>[0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 10.0,...</td>\n",
       "      <td>[3077688, 11354, 1076, 259, 65, 27, 11, 9, 3, 3]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CNT_DRAWINGS_POS_CURRENT</th>\n",
       "      <td>float64</td>\n",
       "      <td>749816</td>\n",
       "      <td>133</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.594791e-01</td>\n",
       "      <td>165.000</td>\n",
       "      <td>3.240649</td>\n",
       "      <td>[0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, ...</td>\n",
       "      <td>[2825594, 72216, 41061, 27337, 20273, 15149, 1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CNT_INSTALMENT_MATURE_CUM</th>\n",
       "      <td>float64</td>\n",
       "      <td>305236</td>\n",
       "      <td>121</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2.082508e+01</td>\n",
       "      <td>120.000</td>\n",
       "      <td>20.051494</td>\n",
       "      <td>[0.0, 5.0, 2.0, 4.0, 6.0, 3.0, 1.0, 7.0, 8.0, ...</td>\n",
       "      <td>[551467, 91691, 91035, 89941, 89829, 89492, 87...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <td>object</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Active', 'Completed', 'Signed', 'Demand', 'S...</td>\n",
       "      <td>[3698436, 128918, 11058, 1365, 513, 17, 5]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK_DPD</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>917</td>\n",
       "      <td>0.000</td>\n",
       "      <td>9.283667e+00</td>\n",
       "      <td>3260.000</td>\n",
       "      <td>97.515700</td>\n",
       "      <td>[0, 1, 8, 32, 7, 62, 31, 366, 93, 18]</td>\n",
       "      <td>[3686957, 90369, 2772, 2340, 1797, 1406, 1290,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK_DPD_DEF</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>378</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.316220e-01</td>\n",
       "      <td>3260.000</td>\n",
       "      <td>21.479231</td>\n",
       "      <td>[0, 1, 8, 7, 32, 5, 31, 18, 12, 62]</td>\n",
       "      <td>[3750972, 83080, 1729, 1176, 492, 406, 291, 25...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           DataType  #Nulls  #Uniques          Min  \\\n",
       "SK_ID_PREV                    int64       0    104307  1000018.000   \n",
       "SK_ID_CURR                    int64       0    103558   100006.000   \n",
       "MONTHS_BALANCE                int64       0        96      -96.000   \n",
       "AMT_BALANCE                 float64       0   1347904  -420250.185   \n",
       "AMT_CREDIT_LIMIT_ACTUAL       int64       0       181        0.000   \n",
       "AMT_DRAWINGS_ATM_CURRENT    float64  749816      2267    -6827.310   \n",
       "AMT_DRAWINGS_CURRENT        float64       0    187005    -6211.620   \n",
       "AMT_DRAWINGS_OTHER_CURRENT  float64  749816      1832        0.000   \n",
       "AMT_DRAWINGS_POS_CURRENT    float64  749816    168748        0.000   \n",
       "AMT_INST_MIN_REGULARITY     float64  305236    312266        0.000   \n",
       "AMT_PAYMENT_CURRENT         float64  767988    163209        0.000   \n",
       "AMT_PAYMENT_TOTAL_CURRENT   float64       0    182957        0.000   \n",
       "AMT_RECEIVABLE_PRINCIPAL    float64       0   1195839  -423305.820   \n",
       "AMT_RECIVABLE               float64       0   1338878  -420250.185   \n",
       "AMT_TOTAL_RECEIVABLE        float64       0   1339008  -420250.185   \n",
       "CNT_DRAWINGS_ATM_CURRENT    float64  749816        44        0.000   \n",
       "CNT_DRAWINGS_CURRENT          int64       0       129        0.000   \n",
       "CNT_DRAWINGS_OTHER_CURRENT  float64  749816        11        0.000   \n",
       "CNT_DRAWINGS_POS_CURRENT    float64  749816       133        0.000   \n",
       "CNT_INSTALMENT_MATURE_CUM   float64  305236       121        0.000   \n",
       "NAME_CONTRACT_STATUS         object       0         7          NaN   \n",
       "SK_DPD                        int64       0       917        0.000   \n",
       "SK_DPD_DEF                    int64       0       378        0.000   \n",
       "\n",
       "                                    Mean          Max            Std  \\\n",
       "SK_ID_PREV                  1.904504e+06  2843496.000  536469.470563   \n",
       "SK_ID_CURR                  2.783242e+05   456250.000  102704.475133   \n",
       "MONTHS_BALANCE             -3.452192e+01       -1.000      26.667751   \n",
       "AMT_BALANCE                 5.830016e+04  1505902.185  106307.031025   \n",
       "AMT_CREDIT_LIMIT_ACTUAL     1.538080e+05  1350000.000  165145.699523   \n",
       "AMT_DRAWINGS_ATM_CURRENT    5.961325e+03  2115000.000   28225.688579   \n",
       "AMT_DRAWINGS_CURRENT        7.433388e+03  2287098.315   33846.077334   \n",
       "AMT_DRAWINGS_OTHER_CURRENT  2.881696e+02  1529847.000    8201.989345   \n",
       "AMT_DRAWINGS_POS_CURRENT    2.968805e+03  2239274.160   20796.887047   \n",
       "AMT_INST_MIN_REGULARITY     3.540204e+03   202882.005    5600.154122   \n",
       "AMT_PAYMENT_CURRENT         1.028054e+04  4289207.445   36078.084953   \n",
       "AMT_PAYMENT_TOTAL_CURRENT   7.588857e+03  4278315.690   32005.987768   \n",
       "AMT_RECEIVABLE_PRINCIPAL    5.596588e+04  1472316.795  102533.616843   \n",
       "AMT_RECIVABLE               5.808881e+04  1493338.185  105965.369908   \n",
       "AMT_TOTAL_RECEIVABLE        5.809829e+04  1493338.185  105971.801103   \n",
       "CNT_DRAWINGS_ATM_CURRENT    3.094490e-01       51.000       1.100401   \n",
       "CNT_DRAWINGS_CURRENT        7.031439e-01      165.000       3.190347   \n",
       "CNT_DRAWINGS_OTHER_CURRENT  4.812496e-03       12.000       0.082639   \n",
       "CNT_DRAWINGS_POS_CURRENT    5.594791e-01      165.000       3.240649   \n",
       "CNT_INSTALMENT_MATURE_CUM   2.082508e+01      120.000      20.051494   \n",
       "NAME_CONTRACT_STATUS                 NaN          NaN            NaN   \n",
       "SK_DPD                      9.283667e+00     3260.000      97.515700   \n",
       "SK_DPD_DEF                  3.316220e-01     3260.000      21.479231   \n",
       "\n",
       "                                                                    top10 val  \\\n",
       "SK_ID_PREV                  [1009171, 1348858, 1745395, 2526035, 1567893, ...   \n",
       "SK_ID_CURR                  [186401, 311118, 120076, 128827, 246089, 19182...   \n",
       "MONTHS_BALANCE                     [-4, -5, -3, -6, -7, -2, -8, -9, -10, -11]   \n",
       "AMT_BALANCE                 [0.0, 67.5, 130.5, 270.0, 135.0, 202.5, 450.0,...   \n",
       "AMT_CREDIT_LIMIT_ACTUAL     [0, 180000, 135000, 45000, 90000, 67500, 45000...   \n",
       "AMT_DRAWINGS_ATM_CURRENT    [0.0, 4500.0, 9000.0, 45000.0, 2250.0, 22500.0...   \n",
       "AMT_DRAWINGS_CURRENT        [0.0, 4500.0, 9000.0, 2250.0, 45000.0, 22500.0...   \n",
       "AMT_DRAWINGS_OTHER_CURRENT  [0.0, 3343.5, 6682.5, 4455.0, 8910.0, 46800.0,...   \n",
       "AMT_DRAWINGS_POS_CURRENT    [0.0, 450.0, 900.0, 2250.0, 4500.0, 1350.0, 22...   \n",
       "AMT_INST_MIN_REGULARITY     [0.0, 9000.0, 6750.0, 3375.0, 4500.0, 2250.0, ...   \n",
       "AMT_PAYMENT_CURRENT         [0.0, 9000.0, 4500.0, 6750.0, 13500.0, 22500.0...   \n",
       "AMT_PAYMENT_TOTAL_CURRENT   [0.0, 9000.0, 4500.0, 6750.0, 13500.0, 22500.0...   \n",
       "AMT_RECEIVABLE_PRINCIPAL    [0.0, 45000.0, 90000.0, 135000.0, 67500.0, 180...   \n",
       "AMT_RECIVABLE               [0.0, 67.5, 270.0, 130.5, 135.0, 202.5, 45000....   \n",
       "AMT_TOTAL_RECEIVABLE        [0.0, 67.5, 270.0, 130.5, 135.0, 202.5, 45000....   \n",
       "CNT_DRAWINGS_ATM_CURRENT    [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, ...   \n",
       "CNT_DRAWINGS_CURRENT                           [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]   \n",
       "CNT_DRAWINGS_OTHER_CURRENT  [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 10.0,...   \n",
       "CNT_DRAWINGS_POS_CURRENT    [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, ...   \n",
       "CNT_INSTALMENT_MATURE_CUM   [0.0, 5.0, 2.0, 4.0, 6.0, 3.0, 1.0, 7.0, 8.0, ...   \n",
       "NAME_CONTRACT_STATUS        ['Active', 'Completed', 'Signed', 'Demand', 'S...   \n",
       "SK_DPD                                  [0, 1, 8, 32, 7, 62, 31, 366, 93, 18]   \n",
       "SK_DPD_DEF                                [0, 1, 8, 7, 32, 5, 31, 18, 12, 62]   \n",
       "\n",
       "                                                                    top10 cnt  \n",
       "SK_ID_PREV                           [96, 96, 96, 96, 96, 96, 96, 96, 96, 96]  \n",
       "SK_ID_CURR                  [192, 178, 140, 129, 128, 128, 128, 127, 127, ...  \n",
       "MONTHS_BALANCE              [102115, 100546, 100355, 98577, 95332, 94643, ...  \n",
       "AMT_BALANCE                 [2156420, 16049, 3662, 2313, 921, 742, 536, 31...  \n",
       "AMT_CREDIT_LIMIT_ACTUAL     [753823, 529292, 430142, 329932, 319996, 30886...  \n",
       "AMT_DRAWINGS_ATM_CURRENT    [2665718, 35851, 27726, 22946, 22854, 22676, 2...  \n",
       "AMT_DRAWINGS_CURRENT        [3223443, 30257, 22968, 20212, 18947, 18670, 1...  \n",
       "AMT_DRAWINGS_OTHER_CURRENT  [3078163, 782, 460, 441, 319, 242, 235, 216, 2...  \n",
       "AMT_DRAWINGS_POS_CURRENT    [2825595, 1287, 976, 910, 801, 784, 609, 462, ...  \n",
       "AMT_INST_MIN_REGULARITY     [1928864, 225429, 147469, 127613, 124979, 1083...  \n",
       "AMT_PAYMENT_CURRENT         [390507, 257297, 143572, 128296, 100454, 56016...  \n",
       "AMT_PAYMENT_TOTAL_CURRENT   [2172223, 250826, 139736, 126483, 94005, 49059...  \n",
       "AMT_RECEIVABLE_PRINCIPAL    [2296167, 5072, 4767, 4513, 3537, 3256, 2034, ...  \n",
       "AMT_RECIVABLE               [2113816, 3144, 2301, 825, 756, 699, 645, 310,...  \n",
       "AMT_TOTAL_RECEIVABLE        [2113643, 3144, 2301, 825, 756, 699, 645, 310,...  \n",
       "CNT_DRAWINGS_ATM_CURRENT    [2665718, 213460, 95647, 46730, 26335, 14910, ...  \n",
       "CNT_DRAWINGS_CURRENT        [3229952, 231319, 116762, 65318, 43290, 28987,...  \n",
       "CNT_DRAWINGS_OTHER_CURRENT   [3077688, 11354, 1076, 259, 65, 27, 11, 9, 3, 3]  \n",
       "CNT_DRAWINGS_POS_CURRENT    [2825594, 72216, 41061, 27337, 20273, 15149, 1...  \n",
       "CNT_INSTALMENT_MATURE_CUM   [551467, 91691, 91035, 89941, 89829, 89492, 87...  \n",
       "NAME_CONTRACT_STATUS               [3698436, 128918, 11058, 1365, 513, 17, 5]  \n",
       "SK_DPD                      [3686957, 90369, 2772, 2340, 1797, 1406, 1290,...  \n",
       "SK_DPD_DEF                  [3750972, 83080, 1729, 1176, 492, 406, 291, 25...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "EDA.df_info(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['SK_ID_PREV', 'SK_ID_CURR', 'MONTHS_BALANCE', 'AMT_BALANCE',\n",
       "       'AMT_CREDIT_LIMIT_ACTUAL', 'AMT_DRAWINGS_ATM_CURRENT',\n",
       "       'AMT_DRAWINGS_CURRENT', 'AMT_DRAWINGS_OTHER_CURRENT',\n",
       "       'AMT_DRAWINGS_POS_CURRENT', 'AMT_INST_MIN_REGULARITY',\n",
       "       'AMT_PAYMENT_CURRENT', 'AMT_PAYMENT_TOTAL_CURRENT',\n",
       "       'AMT_RECEIVABLE_PRINCIPAL', 'AMT_RECIVABLE', 'AMT_TOTAL_RECEIVABLE',\n",
       "       'CNT_DRAWINGS_ATM_CURRENT', 'CNT_DRAWINGS_CURRENT',\n",
       "       'CNT_DRAWINGS_OTHER_CURRENT', 'CNT_DRAWINGS_POS_CURRENT',\n",
       "       'CNT_INSTALMENT_MATURE_CUM', 'NAME_CONTRACT_STATUS', 'SK_DPD',\n",
       "       'SK_DPD_DEF'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "ids = df.SK_ID_CURR.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SK_ID_PREV</th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>MONTHS_BALANCE</th>\n",
       "      <th>AMT_BALANCE</th>\n",
       "      <th>AMT_CREDIT_LIMIT_ACTUAL</th>\n",
       "      <th>AMT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_POS_CURRENT</th>\n",
       "      <th>AMT_INST_MIN_REGULARITY</th>\n",
       "      <th>AMT_PAYMENT_CURRENT</th>\n",
       "      <th>AMT_PAYMENT_TOTAL_CURRENT</th>\n",
       "      <th>AMT_RECEIVABLE_PRINCIPAL</th>\n",
       "      <th>AMT_RECIVABLE</th>\n",
       "      <th>AMT_TOTAL_RECEIVABLE</th>\n",
       "      <th>CNT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_POS_CURRENT</th>\n",
       "      <th>CNT_INSTALMENT_MATURE_CUM</th>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <th>SK_DPD</th>\n",
       "      <th>SK_DPD_DEF</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2073665</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-1</td>\n",
       "      <td>23259.555</td>\n",
       "      <td>90000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25635.420</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25635.420</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2375.865</td>\n",
       "      <td>2375.865</td>\n",
       "      <td>23259.555</td>\n",
       "      <td>23259.555</td>\n",
       "      <td>23259.555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2814426</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-2</td>\n",
       "      <td>0.000</td>\n",
       "      <td>90000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3950.730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3950.730</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5887.575</td>\n",
       "      <td>5887.575</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1606201</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-3</td>\n",
       "      <td>0.000</td>\n",
       "      <td>90000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>165606.750</td>\n",
       "      <td>0.0</td>\n",
       "      <td>165606.750</td>\n",
       "      <td>5315.130</td>\n",
       "      <td>202093.650</td>\n",
       "      <td>202093.650</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2902173</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-4</td>\n",
       "      <td>31144.950</td>\n",
       "      <td>135000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31779.225</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31779.225</td>\n",
       "      <td>0.000</td>\n",
       "      <td>634.275</td>\n",
       "      <td>634.275</td>\n",
       "      <td>31144.950</td>\n",
       "      <td>31144.950</td>\n",
       "      <td>31144.950</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361091</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-5</td>\n",
       "      <td>0.000</td>\n",
       "      <td>135000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>634.275</td>\n",
       "      <td>634.275</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1692812</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-6</td>\n",
       "      <td>0.000</td>\n",
       "      <td>135000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>634.275</td>\n",
       "      <td>634.275</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2617281</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-7</td>\n",
       "      <td>0.000</td>\n",
       "      <td>135000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>634.275</td>\n",
       "      <td>634.275</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386046</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-8</td>\n",
       "      <td>0.000</td>\n",
       "      <td>135000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1350.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1350.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1957.275</td>\n",
       "      <td>1957.275</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3641870</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-9</td>\n",
       "      <td>0.000</td>\n",
       "      <td>135000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41877.540</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41877.540</td>\n",
       "      <td>5411.970</td>\n",
       "      <td>137139.435</td>\n",
       "      <td>137139.435</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3663362</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-10</td>\n",
       "      <td>92585.295</td>\n",
       "      <td>135000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92586.690</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92586.690</td>\n",
       "      <td>1722.015</td>\n",
       "      <td>1723.410</td>\n",
       "      <td>1723.410</td>\n",
       "      <td>92585.295</td>\n",
       "      <td>92585.295</td>\n",
       "      <td>92585.295</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3633647</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-11</td>\n",
       "      <td>1722.015</td>\n",
       "      <td>90000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>162.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>162.000</td>\n",
       "      <td>4626.000</td>\n",
       "      <td>94234.590</td>\n",
       "      <td>94234.590</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.605</td>\n",
       "      <td>7.605</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926825</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-12</td>\n",
       "      <td>91204.965</td>\n",
       "      <td>90000</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>90067.275</td>\n",
       "      <td>0.0</td>\n",
       "      <td>85567.275</td>\n",
       "      <td>0.000</td>\n",
       "      <td>233.595</td>\n",
       "      <td>233.595</td>\n",
       "      <td>89833.680</td>\n",
       "      <td>89859.465</td>\n",
       "      <td>89859.465</td>\n",
       "      <td>1.0</td>\n",
       "      <td>28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3334308</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-13</td>\n",
       "      <td>0.000</td>\n",
       "      <td>90000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29078.730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29078.730</td>\n",
       "      <td>2250.000</td>\n",
       "      <td>45786.555</td>\n",
       "      <td>45786.555</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2486497</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-14</td>\n",
       "      <td>15837.615</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15837.615</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15837.615</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>15837.615</td>\n",
       "      <td>15837.615</td>\n",
       "      <td>15837.615</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3359885</th>\n",
       "      <td>2260534</td>\n",
       "      <td>247469</td>\n",
       "      <td>-15</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         SK_ID_PREV  SK_ID_CURR  MONTHS_BALANCE  AMT_BALANCE  \\\n",
       "2073665     2260534      247469              -1    23259.555   \n",
       "2814426     2260534      247469              -2        0.000   \n",
       "1606201     2260534      247469              -3        0.000   \n",
       "2902173     2260534      247469              -4    31144.950   \n",
       "361091      2260534      247469              -5        0.000   \n",
       "1692812     2260534      247469              -6        0.000   \n",
       "2617281     2260534      247469              -7        0.000   \n",
       "386046      2260534      247469              -8        0.000   \n",
       "3641870     2260534      247469              -9        0.000   \n",
       "3663362     2260534      247469             -10    92585.295   \n",
       "3633647     2260534      247469             -11     1722.015   \n",
       "926825      2260534      247469             -12    91204.965   \n",
       "3334308     2260534      247469             -13        0.000   \n",
       "2486497     2260534      247469             -14    15837.615   \n",
       "3359885     2260534      247469             -15        0.000   \n",
       "\n",
       "         AMT_CREDIT_LIMIT_ACTUAL  AMT_DRAWINGS_ATM_CURRENT  \\\n",
       "2073665                    90000                       0.0   \n",
       "2814426                    90000                       0.0   \n",
       "1606201                    90000                       0.0   \n",
       "2902173                   135000                       0.0   \n",
       "361091                    135000                       0.0   \n",
       "1692812                   135000                       0.0   \n",
       "2617281                   135000                       0.0   \n",
       "386046                    135000                       0.0   \n",
       "3641870                   135000                       0.0   \n",
       "3663362                   135000                       0.0   \n",
       "3633647                    90000                       0.0   \n",
       "926825                     90000                    4500.0   \n",
       "3334308                    90000                       0.0   \n",
       "2486497                    45000                       0.0   \n",
       "3359885                    45000                       NaN   \n",
       "\n",
       "         AMT_DRAWINGS_CURRENT  AMT_DRAWINGS_OTHER_CURRENT  \\\n",
       "2073665             25635.420                         0.0   \n",
       "2814426              3950.730                         0.0   \n",
       "1606201            165606.750                         0.0   \n",
       "2902173             31779.225                         0.0   \n",
       "361091                  0.000                         0.0   \n",
       "1692812                 0.000                         0.0   \n",
       "2617281                 0.000                         0.0   \n",
       "386046               1350.000                         0.0   \n",
       "3641870             41877.540                         0.0   \n",
       "3663362             92586.690                         0.0   \n",
       "3633647               162.000                         0.0   \n",
       "926825              90067.275                         0.0   \n",
       "3334308             29078.730                         0.0   \n",
       "2486497             15837.615                         0.0   \n",
       "3359885                 0.000                         NaN   \n",
       "\n",
       "         AMT_DRAWINGS_POS_CURRENT  AMT_INST_MIN_REGULARITY  \\\n",
       "2073665                 25635.420                    0.000   \n",
       "2814426                  3950.730                    0.000   \n",
       "1606201                165606.750                 5315.130   \n",
       "2902173                 31779.225                    0.000   \n",
       "361091                      0.000                    0.000   \n",
       "1692812                     0.000                    0.000   \n",
       "2617281                     0.000                    0.000   \n",
       "386046                   1350.000                    0.000   \n",
       "3641870                 41877.540                 5411.970   \n",
       "3663362                 92586.690                 1722.015   \n",
       "3633647                   162.000                 4626.000   \n",
       "926825                  85567.275                    0.000   \n",
       "3334308                 29078.730                 2250.000   \n",
       "2486497                 15837.615                    0.000   \n",
       "3359885                       NaN                    0.000   \n",
       "\n",
       "         AMT_PAYMENT_CURRENT  AMT_PAYMENT_TOTAL_CURRENT  \\\n",
       "2073665             2375.865                   2375.865   \n",
       "2814426             5887.575                   5887.575   \n",
       "1606201           202093.650                 202093.650   \n",
       "2902173              634.275                    634.275   \n",
       "361091               634.275                    634.275   \n",
       "1692812              634.275                    634.275   \n",
       "2617281              634.275                    634.275   \n",
       "386046              1957.275                   1957.275   \n",
       "3641870           137139.435                 137139.435   \n",
       "3663362             1723.410                   1723.410   \n",
       "3633647            94234.590                  94234.590   \n",
       "926825               233.595                    233.595   \n",
       "3334308            45786.555                  45786.555   \n",
       "2486497                  NaN                      0.000   \n",
       "3359885                  NaN                      0.000   \n",
       "\n",
       "         AMT_RECEIVABLE_PRINCIPAL  AMT_RECIVABLE  AMT_TOTAL_RECEIVABLE  \\\n",
       "2073665                 23259.555      23259.555             23259.555   \n",
       "2814426                     0.000          0.000                 0.000   \n",
       "1606201                     0.000          0.000                 0.000   \n",
       "2902173                 31144.950      31144.950             31144.950   \n",
       "361091                      0.000          0.000                 0.000   \n",
       "1692812                     0.000          0.000                 0.000   \n",
       "2617281                     0.000          0.000                 0.000   \n",
       "386046                      0.000          0.000                 0.000   \n",
       "3641870                     0.000          0.000                 0.000   \n",
       "3663362                 92585.295      92585.295             92585.295   \n",
       "3633647                     0.000          7.605                 7.605   \n",
       "926825                  89833.680      89859.465             89859.465   \n",
       "3334308                     0.000          0.000                 0.000   \n",
       "2486497                 15837.615      15837.615             15837.615   \n",
       "3359885                     0.000          0.000                 0.000   \n",
       "\n",
       "         CNT_DRAWINGS_ATM_CURRENT  CNT_DRAWINGS_CURRENT  \\\n",
       "2073665                       0.0                     8   \n",
       "2814426                       0.0                     4   \n",
       "1606201                       0.0                    28   \n",
       "2902173                       0.0                    17   \n",
       "361091                        0.0                     0   \n",
       "1692812                       0.0                     0   \n",
       "2617281                       0.0                     0   \n",
       "386046                        0.0                     1   \n",
       "3641870                       0.0                    12   \n",
       "3663362                       0.0                    25   \n",
       "3633647                       0.0                     1   \n",
       "926825                        1.0                    28   \n",
       "3334308                       0.0                     8   \n",
       "2486497                       0.0                     8   \n",
       "3359885                       NaN                     0   \n",
       "\n",
       "         CNT_DRAWINGS_OTHER_CURRENT  CNT_DRAWINGS_POS_CURRENT  \\\n",
       "2073665                         0.0                       8.0   \n",
       "2814426                         0.0                       4.0   \n",
       "1606201                         0.0                      28.0   \n",
       "2902173                         0.0                      17.0   \n",
       "361091                          0.0                       0.0   \n",
       "1692812                         0.0                       0.0   \n",
       "2617281                         0.0                       0.0   \n",
       "386046                          0.0                       1.0   \n",
       "3641870                         0.0                      12.0   \n",
       "3663362                         0.0                      25.0   \n",
       "3633647                         0.0                       1.0   \n",
       "926825                          0.0                      27.0   \n",
       "3334308                         0.0                       8.0   \n",
       "2486497                         0.0                       8.0   \n",
       "3359885                         NaN                       NaN   \n",
       "\n",
       "         CNT_INSTALMENT_MATURE_CUM NAME_CONTRACT_STATUS  SK_DPD  SK_DPD_DEF  \n",
       "2073665                        5.0               Active       0           0  \n",
       "2814426                        5.0               Active       0           0  \n",
       "1606201                        5.0               Active       0           0  \n",
       "2902173                        4.0               Active       0           0  \n",
       "361091                         4.0               Active       0           0  \n",
       "1692812                        4.0               Active       0           0  \n",
       "2617281                        4.0               Active       0           0  \n",
       "386046                         4.0               Active       0           0  \n",
       "3641870                        4.0               Active       0           0  \n",
       "3663362                        3.0               Active       0           0  \n",
       "3633647                        2.0               Active       0           0  \n",
       "926825                         1.0               Active       0           0  \n",
       "3334308                        1.0               Active       0           0  \n",
       "2486497                        0.0               Active       0           0  \n",
       "3359885                        0.0               Active       0           0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp = df[df.SK_ID_CURR==np.random.choice(ids)]\n",
    "tmp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SK_ID_PREV</th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>MONTHS_BALANCE</th>\n",
       "      <th>AMT_BALANCE</th>\n",
       "      <th>AMT_CREDIT_LIMIT_ACTUAL</th>\n",
       "      <th>AMT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <th>AMT_DRAWINGS_POS_CURRENT</th>\n",
       "      <th>AMT_INST_MIN_REGULARITY</th>\n",
       "      <th>AMT_PAYMENT_CURRENT</th>\n",
       "      <th>AMT_PAYMENT_TOTAL_CURRENT</th>\n",
       "      <th>AMT_RECEIVABLE_PRINCIPAL</th>\n",
       "      <th>AMT_RECIVABLE</th>\n",
       "      <th>AMT_TOTAL_RECEIVABLE</th>\n",
       "      <th>CNT_DRAWINGS_ATM_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_OTHER_CURRENT</th>\n",
       "      <th>CNT_DRAWINGS_POS_CURRENT</th>\n",
       "      <th>CNT_INSTALMENT_MATURE_CUM</th>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <th>SK_DPD</th>\n",
       "      <th>SK_DPD_DEF</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2937973</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-2</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1296858</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-3</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480042</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-4</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410641</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-5</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3664165</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-6</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778938</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-7</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1790527</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-8</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823874</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-9</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564185</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-10</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3740876</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-11</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1939891</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-12</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2220721</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-13</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2082256</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-14</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659845</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-15</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1529514</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-16</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2842088</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-17</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2778564</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2781639</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-19</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2929619</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-20</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1328496</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-21</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1593289</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-22</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399970</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-23</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361924</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-24</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2765223</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-25</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1544165</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-26</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2817400</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-27</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2947083</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-28</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2640655</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-29</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1166377</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-30</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3770481</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-31</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1805873</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-32</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1327302</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-33</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2530601</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-34</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851028</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-35</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497028</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-36</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1767484</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-37</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1327044</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-38</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1783057</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-39</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3262270</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-40</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188764</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-41</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3273050</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-42</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60571</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-43</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2478167</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-44</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2674072</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-45</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2605975</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-46</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1075227</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-47</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3753935</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-48</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>-115.830</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2557160</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-49</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3417094</th>\n",
       "      <td>1235896</td>\n",
       "      <td>111387</td>\n",
       "      <td>-50</td>\n",
       "      <td>0.000</td>\n",
       "      <td>67500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>57.915</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1305027</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-15</td>\n",
       "      <td>371792.745</td>\n",
       "      <td>450000</td>\n",
       "      <td>12600.0</td>\n",
       "      <td>18697.500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6097.500</td>\n",
       "      <td>17585.415</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>352406.160</td>\n",
       "      <td>367756.245</td>\n",
       "      <td>367756.245</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510795</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-16</td>\n",
       "      <td>356887.575</td>\n",
       "      <td>337500</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4725.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>225.000</td>\n",
       "      <td>17361.180</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>336198.240</td>\n",
       "      <td>352851.075</td>\n",
       "      <td>352851.075</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2173177</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-17</td>\n",
       "      <td>338222.070</td>\n",
       "      <td>337500</td>\n",
       "      <td>5400.0</td>\n",
       "      <td>9449.145</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4049.145</td>\n",
       "      <td>17062.965</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>638.820</td>\n",
       "      <td>331473.240</td>\n",
       "      <td>336876.570</td>\n",
       "      <td>336876.570</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3300048</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-18</td>\n",
       "      <td>332919.945</td>\n",
       "      <td>337500</td>\n",
       "      <td>2700.0</td>\n",
       "      <td>7276.635</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4576.635</td>\n",
       "      <td>17265.960</td>\n",
       "      <td>36000.000</td>\n",
       "      <td>18937.035</td>\n",
       "      <td>327836.340</td>\n",
       "      <td>332919.945</td>\n",
       "      <td>332919.945</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3064480</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-19</td>\n",
       "      <td>350771.130</td>\n",
       "      <td>337500</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17021.700</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>333684.135</td>\n",
       "      <td>349425.630</td>\n",
       "      <td>349425.630</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213826</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-20</td>\n",
       "      <td>353006.325</td>\n",
       "      <td>337500</td>\n",
       "      <td>6750.0</td>\n",
       "      <td>6750.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17427.195</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>337294.170</td>\n",
       "      <td>351660.825</td>\n",
       "      <td>351660.825</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2616152</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-21</td>\n",
       "      <td>335959.695</td>\n",
       "      <td>337500</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>9000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>16868.250</td>\n",
       "      <td>19350.000</td>\n",
       "      <td>1922.805</td>\n",
       "      <td>330544.170</td>\n",
       "      <td>335959.695</td>\n",
       "      <td>335959.695</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1006764</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-22</td>\n",
       "      <td>319247.415</td>\n",
       "      <td>337500</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>6750.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2250.000</td>\n",
       "      <td>16960.860</td>\n",
       "      <td>33750.000</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>312615.270</td>\n",
       "      <td>317901.915</td>\n",
       "      <td>317901.915</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2189647</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-23</td>\n",
       "      <td>351011.340</td>\n",
       "      <td>337500</td>\n",
       "      <td>2250.0</td>\n",
       "      <td>5400.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3150.000</td>\n",
       "      <td>17365.275</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>334705.635</td>\n",
       "      <td>349665.840</td>\n",
       "      <td>349665.840</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307249</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-24</td>\n",
       "      <td>352739.295</td>\n",
       "      <td>337500</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>4288.230</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2938.230</td>\n",
       "      <td>17502.750</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>336343.410</td>\n",
       "      <td>351393.795</td>\n",
       "      <td>351393.795</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1575132</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-25</td>\n",
       "      <td>319207.995</td>\n",
       "      <td>337500</td>\n",
       "      <td>10800.0</td>\n",
       "      <td>10800.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17234.640</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>497.250</td>\n",
       "      <td>314055.180</td>\n",
       "      <td>319207.995</td>\n",
       "      <td>319207.995</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3657035</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-26</td>\n",
       "      <td>314080.470</td>\n",
       "      <td>337500</td>\n",
       "      <td>6750.0</td>\n",
       "      <td>6750.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17171.865</td>\n",
       "      <td>36000.000</td>\n",
       "      <td>18765.360</td>\n",
       "      <td>308692.800</td>\n",
       "      <td>314080.470</td>\n",
       "      <td>314080.470</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1384466</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-27</td>\n",
       "      <td>348841.710</td>\n",
       "      <td>337500</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17301.285</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>332525.475</td>\n",
       "      <td>347496.210</td>\n",
       "      <td>347496.210</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1584513</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-28</td>\n",
       "      <td>351147.780</td>\n",
       "      <td>337500</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17411.805</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>334736.235</td>\n",
       "      <td>349802.280</td>\n",
       "      <td>349802.280</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2286973</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-29</td>\n",
       "      <td>335720.655</td>\n",
       "      <td>337500</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17534.250</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>588.195</td>\n",
       "      <td>330236.235</td>\n",
       "      <td>335720.655</td>\n",
       "      <td>335720.655</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1866481</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-30</td>\n",
       "      <td>337787.235</td>\n",
       "      <td>337500</td>\n",
       "      <td>21150.0</td>\n",
       "      <td>21375.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>225.000</td>\n",
       "      <td>16442.865</td>\n",
       "      <td>18000.000</td>\n",
       "      <td>465.750</td>\n",
       "      <td>332685.225</td>\n",
       "      <td>337787.235</td>\n",
       "      <td>337787.235</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852909</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-31</td>\n",
       "      <td>304331.850</td>\n",
       "      <td>337500</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>12825.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3825.000</td>\n",
       "      <td>16310.790</td>\n",
       "      <td>33300.000</td>\n",
       "      <td>16857.135</td>\n",
       "      <td>299157.255</td>\n",
       "      <td>304331.850</td>\n",
       "      <td>304331.850</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1703917</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-32</td>\n",
       "      <td>330727.590</td>\n",
       "      <td>337500</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>9000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>16071.435</td>\n",
       "      <td>16200.000</td>\n",
       "      <td>16200.000</td>\n",
       "      <td>314228.520</td>\n",
       "      <td>328036.590</td>\n",
       "      <td>328036.590</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2648540</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-33</td>\n",
       "      <td>326442.240</td>\n",
       "      <td>337500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5581.395</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5581.395</td>\n",
       "      <td>16139.475</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>312170.895</td>\n",
       "      <td>326442.240</td>\n",
       "      <td>326442.240</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2171712</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-34</td>\n",
       "      <td>295392.150</td>\n",
       "      <td>337500</td>\n",
       "      <td>22500.0</td>\n",
       "      <td>25111.485</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2611.485</td>\n",
       "      <td>14869.575</td>\n",
       "      <td>31275.000</td>\n",
       "      <td>15135.525</td>\n",
       "      <td>290389.500</td>\n",
       "      <td>295392.150</td>\n",
       "      <td>295392.150</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1246887</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-35</td>\n",
       "      <td>304563.195</td>\n",
       "      <td>337500</td>\n",
       "      <td>45000.0</td>\n",
       "      <td>48370.005</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3370.005</td>\n",
       "      <td>12475.845</td>\n",
       "      <td>13500.000</td>\n",
       "      <td>13500.000</td>\n",
       "      <td>285976.260</td>\n",
       "      <td>300526.695</td>\n",
       "      <td>300526.695</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880626</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-36</td>\n",
       "      <td>257421.465</td>\n",
       "      <td>337500</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>106007.220</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16007.220</td>\n",
       "      <td>9894.915</td>\n",
       "      <td>22500.000</td>\n",
       "      <td>10024.155</td>\n",
       "      <td>251106.255</td>\n",
       "      <td>254730.465</td>\n",
       "      <td>254730.465</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384299</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-37</td>\n",
       "      <td>158124.960</td>\n",
       "      <td>337500</td>\n",
       "      <td>110250.0</td>\n",
       "      <td>135117.045</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24867.045</td>\n",
       "      <td>3367.125</td>\n",
       "      <td>108000.000</td>\n",
       "      <td>98105.085</td>\n",
       "      <td>153572.895</td>\n",
       "      <td>155433.960</td>\n",
       "      <td>155433.960</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2653179</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-38</td>\n",
       "      <td>119404.170</td>\n",
       "      <td>337500</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>103265.415</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10565.415</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76500.000</td>\n",
       "      <td>73132.875</td>\n",
       "      <td>107607.915</td>\n",
       "      <td>108640.170</td>\n",
       "      <td>108640.170</td>\n",
       "      <td>10.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285525</th>\n",
       "      <td>1640759</td>\n",
       "      <td>351765</td>\n",
       "      <td>-39</td>\n",
       "      <td>77309.865</td>\n",
       "      <td>337500</td>\n",
       "      <td>67500.0</td>\n",
       "      <td>73800.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6300.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>73800.000</td>\n",
       "      <td>74618.865</td>\n",
       "      <td>74618.865</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2214305</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-1</td>\n",
       "      <td>264457.665</td>\n",
       "      <td>495000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>35156.520</td>\n",
       "      <td>225000.000</td>\n",
       "      <td>225000.000</td>\n",
       "      <td>253130.085</td>\n",
       "      <td>264457.665</td>\n",
       "      <td>264457.665</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1147443</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-2</td>\n",
       "      <td>662653.350</td>\n",
       "      <td>900000</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>30454.245</td>\n",
       "      <td>31500.000</td>\n",
       "      <td>31500.000</td>\n",
       "      <td>645084.810</td>\n",
       "      <td>658607.850</td>\n",
       "      <td>658607.850</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395487</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-3</td>\n",
       "      <td>589827.420</td>\n",
       "      <td>900000</td>\n",
       "      <td>360000.0</td>\n",
       "      <td>360000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>11968.920</td>\n",
       "      <td>12150.000</td>\n",
       "      <td>12150.000</td>\n",
       "      <td>574261.110</td>\n",
       "      <td>583774.920</td>\n",
       "      <td>583774.920</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1780746</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-4</td>\n",
       "      <td>228997.305</td>\n",
       "      <td>900000</td>\n",
       "      <td>95400.0</td>\n",
       "      <td>95400.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7024.905</td>\n",
       "      <td>7200.000</td>\n",
       "      <td>7200.000</td>\n",
       "      <td>221498.100</td>\n",
       "      <td>224960.805</td>\n",
       "      <td>224960.805</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1834098</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-5</td>\n",
       "      <td>138345.795</td>\n",
       "      <td>900000</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>135000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>8.640</td>\n",
       "      <td>8.640</td>\n",
       "      <td>134991.360</td>\n",
       "      <td>135654.795</td>\n",
       "      <td>135654.795</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1685821</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-6</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>8.640</td>\n",
       "      <td>8.640</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614221</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-7</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>8.640</td>\n",
       "      <td>8.640</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3240967</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-8</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>8.640</td>\n",
       "      <td>8.640</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182013</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-9</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2250.000</td>\n",
       "      <td>896506.425</td>\n",
       "      <td>896506.425</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3217554</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-10</td>\n",
       "      <td>826861.905</td>\n",
       "      <td>900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>44891.190</td>\n",
       "      <td>45000.000</td>\n",
       "      <td>45000.000</td>\n",
       "      <td>807823.575</td>\n",
       "      <td>826861.905</td>\n",
       "      <td>826861.905</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559498</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-11</td>\n",
       "      <td>887644.665</td>\n",
       "      <td>900000</td>\n",
       "      <td>369000.0</td>\n",
       "      <td>369000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>32106.690</td>\n",
       "      <td>32400.000</td>\n",
       "      <td>32400.000</td>\n",
       "      <td>866233.485</td>\n",
       "      <td>882262.665</td>\n",
       "      <td>882262.665</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3629323</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-12</td>\n",
       "      <td>512175.465</td>\n",
       "      <td>900000</td>\n",
       "      <td>360000.0</td>\n",
       "      <td>360000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7848.000</td>\n",
       "      <td>9000.000</td>\n",
       "      <td>9000.000</td>\n",
       "      <td>498959.640</td>\n",
       "      <td>506793.465</td>\n",
       "      <td>506793.465</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3763686</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-13</td>\n",
       "      <td>145628.955</td>\n",
       "      <td>900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>8012.475</td>\n",
       "      <td>9000.000</td>\n",
       "      <td>9000.000</td>\n",
       "      <td>142249.680</td>\n",
       "      <td>145628.955</td>\n",
       "      <td>145628.955</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3446494</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-14</td>\n",
       "      <td>150692.175</td>\n",
       "      <td>900000</td>\n",
       "      <td>157500.0</td>\n",
       "      <td>157500.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>6919.380</td>\n",
       "      <td>7200.000</td>\n",
       "      <td>7200.000</td>\n",
       "      <td>146487.285</td>\n",
       "      <td>149346.675</td>\n",
       "      <td>149346.675</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1800298</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-15</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1292702</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-16</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003624</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-17</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>956496</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2182853</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-19</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2306198</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-20</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3807364</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-21</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3298174</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-22</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2540885</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-23</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2622366</th>\n",
       "      <td>2705073</td>\n",
       "      <td>401415</td>\n",
       "      <td>-24</td>\n",
       "      <td>0.000</td>\n",
       "      <td>900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Active</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>583 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         SK_ID_PREV  SK_ID_CURR  MONTHS_BALANCE  AMT_BALANCE  \\\n",
       "2937973     1235896      111387              -2        0.000   \n",
       "1296858     1235896      111387              -3        0.000   \n",
       "480042      1235896      111387              -4        0.000   \n",
       "410641      1235896      111387              -5        0.000   \n",
       "3664165     1235896      111387              -6        0.000   \n",
       "778938      1235896      111387              -7        0.000   \n",
       "1790527     1235896      111387              -8        0.000   \n",
       "823874      1235896      111387              -9        0.000   \n",
       "564185      1235896      111387             -10        0.000   \n",
       "3740876     1235896      111387             -11        0.000   \n",
       "1939891     1235896      111387             -12        0.000   \n",
       "2220721     1235896      111387             -13        0.000   \n",
       "2082256     1235896      111387             -14        0.000   \n",
       "659845      1235896      111387             -15        0.000   \n",
       "1529514     1235896      111387             -16        0.000   \n",
       "2842088     1235896      111387             -17        0.000   \n",
       "2778564     1235896      111387             -18        0.000   \n",
       "2781639     1235896      111387             -19        0.000   \n",
       "2929619     1235896      111387             -20        0.000   \n",
       "1328496     1235896      111387             -21        0.000   \n",
       "1593289     1235896      111387             -22        0.000   \n",
       "399970      1235896      111387             -23        0.000   \n",
       "361924      1235896      111387             -24        0.000   \n",
       "2765223     1235896      111387             -25        0.000   \n",
       "1544165     1235896      111387             -26        0.000   \n",
       "2817400     1235896      111387             -27        0.000   \n",
       "2947083     1235896      111387             -28        0.000   \n",
       "2640655     1235896      111387             -29        0.000   \n",
       "1166377     1235896      111387             -30        0.000   \n",
       "3770481     1235896      111387             -31        0.000   \n",
       "1805873     1235896      111387             -32        0.000   \n",
       "1327302     1235896      111387             -33        0.000   \n",
       "2530601     1235896      111387             -34        0.000   \n",
       "1851028     1235896      111387             -35        0.000   \n",
       "497028      1235896      111387             -36        0.000   \n",
       "1767484     1235896      111387             -37        0.000   \n",
       "1327044     1235896      111387             -38        0.000   \n",
       "1783057     1235896      111387             -39        0.000   \n",
       "3262270     1235896      111387             -40        0.000   \n",
       "188764      1235896      111387             -41        0.000   \n",
       "3273050     1235896      111387             -42        0.000   \n",
       "60571       1235896      111387             -43        0.000   \n",
       "2478167     1235896      111387             -44        0.000   \n",
       "2674072     1235896      111387             -45        0.000   \n",
       "2605975     1235896      111387             -46        0.000   \n",
       "1075227     1235896      111387             -47        0.000   \n",
       "3753935     1235896      111387             -48        0.000   \n",
       "2557160     1235896      111387             -49        0.000   \n",
       "3417094     1235896      111387             -50        0.000   \n",
       "...             ...         ...             ...          ...   \n",
       "1305027     1640759      351765             -15   371792.745   \n",
       "510795      1640759      351765             -16   356887.575   \n",
       "2173177     1640759      351765             -17   338222.070   \n",
       "3300048     1640759      351765             -18   332919.945   \n",
       "3064480     1640759      351765             -19   350771.130   \n",
       "213826      1640759      351765             -20   353006.325   \n",
       "2616152     1640759      351765             -21   335959.695   \n",
       "1006764     1640759      351765             -22   319247.415   \n",
       "2189647     1640759      351765             -23   351011.340   \n",
       "307249      1640759      351765             -24   352739.295   \n",
       "1575132     1640759      351765             -25   319207.995   \n",
       "3657035     1640759      351765             -26   314080.470   \n",
       "1384466     1640759      351765             -27   348841.710   \n",
       "1584513     1640759      351765             -28   351147.780   \n",
       "2286973     1640759      351765             -29   335720.655   \n",
       "1866481     1640759      351765             -30   337787.235   \n",
       "1852909     1640759      351765             -31   304331.850   \n",
       "1703917     1640759      351765             -32   330727.590   \n",
       "2648540     1640759      351765             -33   326442.240   \n",
       "2171712     1640759      351765             -34   295392.150   \n",
       "1246887     1640759      351765             -35   304563.195   \n",
       "1880626     1640759      351765             -36   257421.465   \n",
       "384299      1640759      351765             -37   158124.960   \n",
       "2653179     1640759      351765             -38   119404.170   \n",
       "285525      1640759      351765             -39    77309.865   \n",
       "2214305     2705073      401415              -1   264457.665   \n",
       "1147443     2705073      401415              -2   662653.350   \n",
       "395487      2705073      401415              -3   589827.420   \n",
       "1780746     2705073      401415              -4   228997.305   \n",
       "1834098     2705073      401415              -5   138345.795   \n",
       "1685821     2705073      401415              -6        0.000   \n",
       "614221      2705073      401415              -7        0.000   \n",
       "3240967     2705073      401415              -8        0.000   \n",
       "182013      2705073      401415              -9        0.000   \n",
       "3217554     2705073      401415             -10   826861.905   \n",
       "559498      2705073      401415             -11   887644.665   \n",
       "3629323     2705073      401415             -12   512175.465   \n",
       "3763686     2705073      401415             -13   145628.955   \n",
       "3446494     2705073      401415             -14   150692.175   \n",
       "1800298     2705073      401415             -15        0.000   \n",
       "1292702     2705073      401415             -16        0.000   \n",
       "1003624     2705073      401415             -17        0.000   \n",
       "956496      2705073      401415             -18        0.000   \n",
       "2182853     2705073      401415             -19        0.000   \n",
       "2306198     2705073      401415             -20        0.000   \n",
       "3807364     2705073      401415             -21        0.000   \n",
       "3298174     2705073      401415             -22        0.000   \n",
       "2540885     2705073      401415             -23        0.000   \n",
       "2622366     2705073      401415             -24        0.000   \n",
       "\n",
       "         AMT_CREDIT_LIMIT_ACTUAL  AMT_DRAWINGS_ATM_CURRENT  \\\n",
       "2937973                    45000                       0.0   \n",
       "1296858                    45000                       0.0   \n",
       "480042                     45000                       0.0   \n",
       "410641                     45000                       0.0   \n",
       "3664165                    45000                       0.0   \n",
       "778938                     45000                       0.0   \n",
       "1790527                    45000                       0.0   \n",
       "823874                     45000                       0.0   \n",
       "564185                     45000                       0.0   \n",
       "3740876                    45000                       0.0   \n",
       "1939891                    45000                       0.0   \n",
       "2220721                    45000                       0.0   \n",
       "2082256                    45000                       0.0   \n",
       "659845                     45000                       0.0   \n",
       "1529514                    45000                       0.0   \n",
       "2842088                    67500                       0.0   \n",
       "2778564                    67500                       0.0   \n",
       "2781639                    67500                       0.0   \n",
       "2929619                    67500                       0.0   \n",
       "1328496                    67500                       0.0   \n",
       "1593289                    67500                       0.0   \n",
       "399970                     67500                       0.0   \n",
       "361924                     67500                       0.0   \n",
       "2765223                    67500                       0.0   \n",
       "1544165                    67500                       0.0   \n",
       "2817400                    67500                       0.0   \n",
       "2947083                    67500                       0.0   \n",
       "2640655                    67500                       0.0   \n",
       "1166377                    67500                       0.0   \n",
       "3770481                    67500                       0.0   \n",
       "1805873                    67500                       0.0   \n",
       "1327302                    67500                       0.0   \n",
       "2530601                    67500                       0.0   \n",
       "1851028                    67500                       0.0   \n",
       "497028                     67500                       0.0   \n",
       "1767484                    67500                       0.0   \n",
       "1327044                    67500                       0.0   \n",
       "1783057                    67500                       0.0   \n",
       "3262270                    67500                       0.0   \n",
       "188764                     67500                       0.0   \n",
       "3273050                    67500                       0.0   \n",
       "60571                      67500                       0.0   \n",
       "2478167                    67500                       0.0   \n",
       "2674072                    67500                       0.0   \n",
       "2605975                    67500                       0.0   \n",
       "1075227                    67500                       0.0   \n",
       "3753935                    67500                       0.0   \n",
       "2557160                    67500                       0.0   \n",
       "3417094                    67500                       0.0   \n",
       "...                          ...                       ...   \n",
       "1305027                   450000                   12600.0   \n",
       "510795                    337500                    4500.0   \n",
       "2173177                   337500                    5400.0   \n",
       "3300048                   337500                    2700.0   \n",
       "3064480                   337500                    4500.0   \n",
       "213826                    337500                    6750.0   \n",
       "2616152                   337500                    9000.0   \n",
       "1006764                   337500                    4500.0   \n",
       "2189647                   337500                    2250.0   \n",
       "307249                    337500                    1350.0   \n",
       "1575132                   337500                   10800.0   \n",
       "3657035                   337500                    6750.0   \n",
       "1384466                   337500                    4500.0   \n",
       "1584513                   337500                    4500.0   \n",
       "2286973                   337500                    4500.0   \n",
       "1866481                   337500                   21150.0   \n",
       "1852909                   337500                    9000.0   \n",
       "1703917                   337500                    9000.0   \n",
       "2648540                   337500                       0.0   \n",
       "2171712                   337500                   22500.0   \n",
       "1246887                   337500                   45000.0   \n",
       "1880626                   337500                   90000.0   \n",
       "384299                    337500                  110250.0   \n",
       "2653179                   337500                   92700.0   \n",
       "285525                    337500                   67500.0   \n",
       "2214305                   495000                       0.0   \n",
       "1147443                   900000                   99000.0   \n",
       "395487                    900000                  360000.0   \n",
       "1780746                   900000                   95400.0   \n",
       "1834098                   900000                  135000.0   \n",
       "1685821                   900000                       0.0   \n",
       "614221                    900000                       0.0   \n",
       "3240967                   900000                       0.0   \n",
       "182013                    900000                       0.0   \n",
       "3217554                   900000                       0.0   \n",
       "559498                    900000                  369000.0   \n",
       "3629323                   900000                  360000.0   \n",
       "3763686                   900000                       0.0   \n",
       "3446494                   900000                  157500.0   \n",
       "1800298                   900000                       NaN   \n",
       "1292702                   900000                       NaN   \n",
       "1003624                   900000                       NaN   \n",
       "956496                    900000                       NaN   \n",
       "2182853                   900000                       NaN   \n",
       "2306198                   900000                       NaN   \n",
       "3807364                   900000                       NaN   \n",
       "3298174                   900000                       NaN   \n",
       "2540885                   900000                       NaN   \n",
       "2622366                   900000                       NaN   \n",
       "\n",
       "         AMT_DRAWINGS_CURRENT  AMT_DRAWINGS_OTHER_CURRENT  \\\n",
       "2937973                 0.000                         0.0   \n",
       "1296858                 0.000                         0.0   \n",
       "480042                  0.000                         0.0   \n",
       "410641                  0.000                         0.0   \n",
       "3664165                 0.000                         0.0   \n",
       "778938                  0.000                         0.0   \n",
       "1790527                 0.000                         0.0   \n",
       "823874                  0.000                         0.0   \n",
       "564185                  0.000                         0.0   \n",
       "3740876                 0.000                         0.0   \n",
       "1939891                 0.000                         0.0   \n",
       "2220721                 0.000                         0.0   \n",
       "2082256                 0.000                         0.0   \n",
       "659845                  0.000                         0.0   \n",
       "1529514                 0.000                         0.0   \n",
       "2842088                 0.000                         0.0   \n",
       "2778564                 0.000                         0.0   \n",
       "2781639                 0.000                         0.0   \n",
       "2929619                 0.000                         0.0   \n",
       "1328496                 0.000                         0.0   \n",
       "1593289                 0.000                         0.0   \n",
       "399970                  0.000                         0.0   \n",
       "361924                  0.000                         0.0   \n",
       "2765223                 0.000                         0.0   \n",
       "1544165                 0.000                         0.0   \n",
       "2817400                 0.000                         0.0   \n",
       "2947083                 0.000                         0.0   \n",
       "2640655                 0.000                         0.0   \n",
       "1166377                 0.000                         0.0   \n",
       "3770481                 0.000                         0.0   \n",
       "1805873                 0.000                         0.0   \n",
       "1327302                 0.000                         0.0   \n",
       "2530601                 0.000                         0.0   \n",
       "1851028                 0.000                         0.0   \n",
       "497028                  0.000                         0.0   \n",
       "1767484                 0.000                         0.0   \n",
       "1327044                 0.000                         0.0   \n",
       "1783057                 0.000                         0.0   \n",
       "3262270                 0.000                         0.0   \n",
       "188764                  0.000                         0.0   \n",
       "3273050                 0.000                         0.0   \n",
       "60571                   0.000                         0.0   \n",
       "2478167                 0.000                         0.0   \n",
       "2674072                 0.000                         0.0   \n",
       "2605975                 0.000                         0.0   \n",
       "1075227                 0.000                         0.0   \n",
       "3753935                 0.000                         0.0   \n",
       "2557160                 0.000                         0.0   \n",
       "3417094                 0.000                         0.0   \n",
       "...                       ...                         ...   \n",
       "1305027             18697.500                         0.0   \n",
       "510795               4725.000                         0.0   \n",
       "2173177              9449.145                         0.0   \n",
       "3300048              7276.635                         0.0   \n",
       "3064480              4500.000                         0.0   \n",
       "213826               6750.000                         0.0   \n",
       "2616152              9000.000                         0.0   \n",
       "1006764              6750.000                         0.0   \n",
       "2189647              5400.000                         0.0   \n",
       "307249               4288.230                         0.0   \n",
       "1575132             10800.000                         0.0   \n",
       "3657035              6750.000                         0.0   \n",
       "1384466              4500.000                         0.0   \n",
       "1584513              4500.000                         0.0   \n",
       "2286973              4500.000                         0.0   \n",
       "1866481             21375.000                         0.0   \n",
       "1852909             12825.000                         0.0   \n",
       "1703917              9000.000                         0.0   \n",
       "2648540              5581.395                         0.0   \n",
       "2171712             25111.485                         0.0   \n",
       "1246887             48370.005                         0.0   \n",
       "1880626            106007.220                         0.0   \n",
       "384299             135117.045                         0.0   \n",
       "2653179            103265.415                         0.0   \n",
       "285525              73800.000                         0.0   \n",
       "2214305                 0.000                         0.0   \n",
       "1147443             99000.000                         0.0   \n",
       "395487             360000.000                         0.0   \n",
       "1780746             95400.000                         0.0   \n",
       "1834098            135000.000                         0.0   \n",
       "1685821                 0.000                         0.0   \n",
       "614221                  0.000                         0.0   \n",
       "3240967                 0.000                         0.0   \n",
       "182013                  0.000                         0.0   \n",
       "3217554                 0.000                         0.0   \n",
       "559498             369000.000                         0.0   \n",
       "3629323            360000.000                         0.0   \n",
       "3763686                 0.000                         0.0   \n",
       "3446494            157500.000                         0.0   \n",
       "1800298                 0.000                         NaN   \n",
       "1292702                 0.000                         NaN   \n",
       "1003624                 0.000                         NaN   \n",
       "956496                  0.000                         NaN   \n",
       "2182853                 0.000                         NaN   \n",
       "2306198                 0.000                         NaN   \n",
       "3807364                 0.000                         NaN   \n",
       "3298174                 0.000                         NaN   \n",
       "2540885                 0.000                         NaN   \n",
       "2622366                 0.000                         NaN   \n",
       "\n",
       "         AMT_DRAWINGS_POS_CURRENT  AMT_INST_MIN_REGULARITY  \\\n",
       "2937973                     0.000                    0.000   \n",
       "1296858                     0.000                    0.000   \n",
       "480042                      0.000                    0.000   \n",
       "410641                      0.000                    0.000   \n",
       "3664165                     0.000                    0.000   \n",
       "778938                      0.000                    0.000   \n",
       "1790527                     0.000                    0.000   \n",
       "823874                      0.000                    0.000   \n",
       "564185                      0.000                    0.000   \n",
       "3740876                     0.000                    0.000   \n",
       "1939891                     0.000                    0.000   \n",
       "2220721                     0.000                    0.000   \n",
       "2082256                     0.000                    0.000   \n",
       "659845                      0.000                    0.000   \n",
       "1529514                     0.000                    0.000   \n",
       "2842088                     0.000                    0.000   \n",
       "2778564                     0.000                    0.000   \n",
       "2781639                     0.000                    0.000   \n",
       "2929619                     0.000                    0.000   \n",
       "1328496                     0.000                    0.000   \n",
       "1593289                     0.000                    0.000   \n",
       "399970                      0.000                    0.000   \n",
       "361924                      0.000                    0.000   \n",
       "2765223                     0.000                    0.000   \n",
       "1544165                     0.000                    0.000   \n",
       "2817400                     0.000                    0.000   \n",
       "2947083                     0.000                    0.000   \n",
       "2640655                     0.000                    0.000   \n",
       "1166377                     0.000                    0.000   \n",
       "3770481                     0.000                    0.000   \n",
       "1805873                     0.000                    0.000   \n",
       "1327302                     0.000                    0.000   \n",
       "2530601                     0.000                    0.000   \n",
       "1851028                     0.000                    0.000   \n",
       "497028                      0.000                    0.000   \n",
       "1767484                     0.000                    0.000   \n",
       "1327044                     0.000                    0.000   \n",
       "1783057                     0.000                    0.000   \n",
       "3262270                     0.000                    0.000   \n",
       "188764                      0.000                    0.000   \n",
       "3273050                     0.000                    0.000   \n",
       "60571                       0.000                    0.000   \n",
       "2478167                     0.000                    0.000   \n",
       "2674072                     0.000                    0.000   \n",
       "2605975                     0.000                    0.000   \n",
       "1075227                     0.000                    0.000   \n",
       "3753935                     0.000                    0.000   \n",
       "2557160                     0.000                    0.000   \n",
       "3417094                     0.000                    0.000   \n",
       "...                           ...                      ...   \n",
       "1305027                  6097.500                17585.415   \n",
       "510795                    225.000                17361.180   \n",
       "2173177                  4049.145                17062.965   \n",
       "3300048                  4576.635                17265.960   \n",
       "3064480                     0.000                17021.700   \n",
       "213826                      0.000                17427.195   \n",
       "2616152                     0.000                16868.250   \n",
       "1006764                  2250.000                16960.860   \n",
       "2189647                  3150.000                17365.275   \n",
       "307249                   2938.230                17502.750   \n",
       "1575132                     0.000                17234.640   \n",
       "3657035                     0.000                17171.865   \n",
       "1384466                     0.000                17301.285   \n",
       "1584513                     0.000                17411.805   \n",
       "2286973                     0.000                17534.250   \n",
       "1866481                   225.000                16442.865   \n",
       "1852909                  3825.000                16310.790   \n",
       "1703917                     0.000                16071.435   \n",
       "2648540                  5581.395                16139.475   \n",
       "2171712                  2611.485                14869.575   \n",
       "1246887                  3370.005                12475.845   \n",
       "1880626                 16007.220                 9894.915   \n",
       "384299                  24867.045                 3367.125   \n",
       "2653179                 10565.415                      NaN   \n",
       "285525                   6300.000                      NaN   \n",
       "2214305                     0.000                35156.520   \n",
       "1147443                     0.000                30454.245   \n",
       "395487                      0.000                11968.920   \n",
       "1780746                     0.000                 7024.905   \n",
       "1834098                     0.000                    0.000   \n",
       "1685821                     0.000                    0.000   \n",
       "614221                      0.000                    0.000   \n",
       "3240967                     0.000                    0.000   \n",
       "182013                      0.000                 2250.000   \n",
       "3217554                     0.000                44891.190   \n",
       "559498                      0.000                32106.690   \n",
       "3629323                     0.000                 7848.000   \n",
       "3763686                     0.000                 8012.475   \n",
       "3446494                     0.000                 6919.380   \n",
       "1800298                       NaN                    0.000   \n",
       "1292702                       NaN                    0.000   \n",
       "1003624                       NaN                    0.000   \n",
       "956496                        NaN                    0.000   \n",
       "2182853                       NaN                    0.000   \n",
       "2306198                       NaN                    0.000   \n",
       "3807364                       NaN                    0.000   \n",
       "3298174                       NaN                    0.000   \n",
       "2540885                       NaN                    0.000   \n",
       "2622366                       NaN                    0.000   \n",
       "\n",
       "         AMT_PAYMENT_CURRENT  AMT_PAYMENT_TOTAL_CURRENT  \\\n",
       "2937973               57.915                      0.000   \n",
       "1296858               57.915                      0.000   \n",
       "480042                57.915                      0.000   \n",
       "410641                57.915                      0.000   \n",
       "3664165               57.915                      0.000   \n",
       "778938                57.915                      0.000   \n",
       "1790527               57.915                      0.000   \n",
       "823874                57.915                      0.000   \n",
       "564185                57.915                      0.000   \n",
       "3740876               57.915                      0.000   \n",
       "1939891               57.915                      0.000   \n",
       "2220721               57.915                      0.000   \n",
       "2082256               57.915                      0.000   \n",
       "659845                57.915                      0.000   \n",
       "1529514               57.915                      0.000   \n",
       "2842088               57.915                      0.000   \n",
       "2778564               57.915                      0.000   \n",
       "2781639               57.915                      0.000   \n",
       "2929619               57.915                      0.000   \n",
       "1328496               57.915                      0.000   \n",
       "1593289               57.915                      0.000   \n",
       "399970                57.915                      0.000   \n",
       "361924                57.915                      0.000   \n",
       "2765223               57.915                      0.000   \n",
       "1544165               57.915                      0.000   \n",
       "2817400               57.915                      0.000   \n",
       "2947083               57.915                      0.000   \n",
       "2640655               57.915                      0.000   \n",
       "1166377               57.915                      0.000   \n",
       "3770481               57.915                      0.000   \n",
       "1805873               57.915                      0.000   \n",
       "1327302               57.915                      0.000   \n",
       "2530601               57.915                      0.000   \n",
       "1851028               57.915                      0.000   \n",
       "497028                57.915                      0.000   \n",
       "1767484               57.915                      0.000   \n",
       "1327044               57.915                      0.000   \n",
       "1783057               57.915                      0.000   \n",
       "3262270               57.915                      0.000   \n",
       "188764                57.915                      0.000   \n",
       "3273050               57.915                      0.000   \n",
       "60571                 57.915                      0.000   \n",
       "2478167               57.915                      0.000   \n",
       "2674072               57.915                      0.000   \n",
       "2605975               57.915                      0.000   \n",
       "1075227               57.915                      0.000   \n",
       "3753935               57.915                      0.000   \n",
       "2557160               57.915                      0.000   \n",
       "3417094               57.915                      0.000   \n",
       "...                      ...                        ...   \n",
       "1305027            18000.000                  18000.000   \n",
       "510795                 0.000                      0.000   \n",
       "2173177            18000.000                    638.820   \n",
       "3300048            36000.000                  18937.035   \n",
       "3064480            18000.000                  18000.000   \n",
       "213826                 0.000                      0.000   \n",
       "2616152            19350.000                   1922.805   \n",
       "1006764            33750.000                  18000.000   \n",
       "2189647            18000.000                  18000.000   \n",
       "307249                 0.000                      0.000   \n",
       "1575132            18000.000                    497.250   \n",
       "3657035            36000.000                  18765.360   \n",
       "1384466            18000.000                  18000.000   \n",
       "1584513                0.000                      0.000   \n",
       "2286973            18000.000                    588.195   \n",
       "1866481            18000.000                    465.750   \n",
       "1852909            33300.000                  16857.135   \n",
       "1703917            16200.000                  16200.000   \n",
       "2648540                0.000                      0.000   \n",
       "2171712            31275.000                  15135.525   \n",
       "1246887            13500.000                  13500.000   \n",
       "1880626            22500.000                  10024.155   \n",
       "384299            108000.000                  98105.085   \n",
       "2653179            76500.000                  73132.875   \n",
       "285525                 0.000                      0.000   \n",
       "2214305           225000.000                 225000.000   \n",
       "1147443            31500.000                  31500.000   \n",
       "395487             12150.000                  12150.000   \n",
       "1780746             7200.000                   7200.000   \n",
       "1834098                8.640                      8.640   \n",
       "1685821                8.640                      8.640   \n",
       "614221                 8.640                      8.640   \n",
       "3240967                8.640                      8.640   \n",
       "182013            896506.425                 896506.425   \n",
       "3217554            45000.000                  45000.000   \n",
       "559498             32400.000                  32400.000   \n",
       "3629323             9000.000                   9000.000   \n",
       "3763686             9000.000                   9000.000   \n",
       "3446494             7200.000                   7200.000   \n",
       "1800298                  NaN                      0.000   \n",
       "1292702                  NaN                      0.000   \n",
       "1003624                  NaN                      0.000   \n",
       "956496                   NaN                      0.000   \n",
       "2182853                  NaN                      0.000   \n",
       "2306198                  NaN                      0.000   \n",
       "3807364                  NaN                      0.000   \n",
       "3298174                  NaN                      0.000   \n",
       "2540885                  NaN                      0.000   \n",
       "2622366                  NaN                      0.000   \n",
       "\n",
       "         AMT_RECEIVABLE_PRINCIPAL  AMT_RECIVABLE  AMT_TOTAL_RECEIVABLE  \\\n",
       "2937973                     0.000          0.000                 0.000   \n",
       "1296858                     0.000          0.000                 0.000   \n",
       "480042                      0.000          0.000                 0.000   \n",
       "410641                      0.000          0.000                 0.000   \n",
       "3664165                     0.000          0.000                 0.000   \n",
       "778938                      0.000          0.000                 0.000   \n",
       "1790527                     0.000          0.000                 0.000   \n",
       "823874                      0.000          0.000                 0.000   \n",
       "564185                      0.000          0.000                 0.000   \n",
       "3740876                     0.000          0.000                 0.000   \n",
       "1939891                     0.000          0.000                 0.000   \n",
       "2220721                     0.000          0.000                 0.000   \n",
       "2082256                     0.000          0.000                 0.000   \n",
       "659845                      0.000          0.000                 0.000   \n",
       "1529514                     0.000          0.000                 0.000   \n",
       "2842088                     0.000          0.000                 0.000   \n",
       "2778564                     0.000          0.000                 0.000   \n",
       "2781639                     0.000          0.000                 0.000   \n",
       "2929619                     0.000          0.000                 0.000   \n",
       "1328496                     0.000          0.000                 0.000   \n",
       "1593289                     0.000          0.000                 0.000   \n",
       "399970                      0.000          0.000                 0.000   \n",
       "361924                      0.000          0.000                 0.000   \n",
       "2765223                     0.000          0.000                 0.000   \n",
       "1544165                     0.000          0.000                 0.000   \n",
       "2817400                     0.000          0.000                 0.000   \n",
       "2947083                     0.000          0.000                 0.000   \n",
       "2640655                     0.000          0.000                 0.000   \n",
       "1166377                     0.000          0.000                 0.000   \n",
       "3770481                     0.000          0.000                 0.000   \n",
       "1805873                     0.000          0.000                 0.000   \n",
       "1327302                     0.000          0.000                 0.000   \n",
       "2530601                     0.000          0.000                 0.000   \n",
       "1851028                     0.000          0.000                 0.000   \n",
       "497028                      0.000          0.000                 0.000   \n",
       "1767484                     0.000          0.000                 0.000   \n",
       "1327044                     0.000          0.000                 0.000   \n",
       "1783057                     0.000          0.000                 0.000   \n",
       "3262270                     0.000          0.000                 0.000   \n",
       "188764                      0.000       -115.830              -115.830   \n",
       "3273050                     0.000       -115.830              -115.830   \n",
       "60571                       0.000       -115.830              -115.830   \n",
       "2478167                     0.000       -115.830              -115.830   \n",
       "2674072                     0.000       -115.830              -115.830   \n",
       "2605975                     0.000       -115.830              -115.830   \n",
       "1075227                     0.000       -115.830              -115.830   \n",
       "3753935                     0.000       -115.830              -115.830   \n",
       "2557160                     0.000          0.000                 0.000   \n",
       "3417094                     0.000          0.000                 0.000   \n",
       "...                           ...            ...                   ...   \n",
       "1305027                352406.160     367756.245            367756.245   \n",
       "510795                 336198.240     352851.075            352851.075   \n",
       "2173177                331473.240     336876.570            336876.570   \n",
       "3300048                327836.340     332919.945            332919.945   \n",
       "3064480                333684.135     349425.630            349425.630   \n",
       "213826                 337294.170     351660.825            351660.825   \n",
       "2616152                330544.170     335959.695            335959.695   \n",
       "1006764                312615.270     317901.915            317901.915   \n",
       "2189647                334705.635     349665.840            349665.840   \n",
       "307249                 336343.410     351393.795            351393.795   \n",
       "1575132                314055.180     319207.995            319207.995   \n",
       "3657035                308692.800     314080.470            314080.470   \n",
       "1384466                332525.475     347496.210            347496.210   \n",
       "1584513                334736.235     349802.280            349802.280   \n",
       "2286973                330236.235     335720.655            335720.655   \n",
       "1866481                332685.225     337787.235            337787.235   \n",
       "1852909                299157.255     304331.850            304331.850   \n",
       "1703917                314228.520     328036.590            328036.590   \n",
       "2648540                312170.895     326442.240            326442.240   \n",
       "2171712                290389.500     295392.150            295392.150   \n",
       "1246887                285976.260     300526.695            300526.695   \n",
       "1880626                251106.255     254730.465            254730.465   \n",
       "384299                 153572.895     155433.960            155433.960   \n",
       "2653179                107607.915     108640.170            108640.170   \n",
       "285525                  73800.000      74618.865             74618.865   \n",
       "2214305                253130.085     264457.665            264457.665   \n",
       "1147443                645084.810     658607.850            658607.850   \n",
       "395487                 574261.110     583774.920            583774.920   \n",
       "1780746                221498.100     224960.805            224960.805   \n",
       "1834098                134991.360     135654.795            135654.795   \n",
       "1685821                     0.000          0.000                 0.000   \n",
       "614221                      0.000          0.000                 0.000   \n",
       "3240967                     0.000          0.000                 0.000   \n",
       "182013                      0.000          0.000                 0.000   \n",
       "3217554                807823.575     826861.905            826861.905   \n",
       "559498                 866233.485     882262.665            882262.665   \n",
       "3629323                498959.640     506793.465            506793.465   \n",
       "3763686                142249.680     145628.955            145628.955   \n",
       "3446494                146487.285     149346.675            149346.675   \n",
       "1800298                     0.000          0.000                 0.000   \n",
       "1292702                     0.000          0.000                 0.000   \n",
       "1003624                     0.000          0.000                 0.000   \n",
       "956496                      0.000          0.000                 0.000   \n",
       "2182853                     0.000          0.000                 0.000   \n",
       "2306198                     0.000          0.000                 0.000   \n",
       "3807364                     0.000          0.000                 0.000   \n",
       "3298174                     0.000          0.000                 0.000   \n",
       "2540885                     0.000          0.000                 0.000   \n",
       "2622366                     0.000          0.000                 0.000   \n",
       "\n",
       "         CNT_DRAWINGS_ATM_CURRENT  CNT_DRAWINGS_CURRENT  \\\n",
       "2937973                       0.0                     0   \n",
       "1296858                       0.0                     0   \n",
       "480042                        0.0                     0   \n",
       "410641                        0.0                     0   \n",
       "3664165                       0.0                     0   \n",
       "778938                        0.0                     0   \n",
       "1790527                       0.0                     0   \n",
       "823874                        0.0                     0   \n",
       "564185                        0.0                     0   \n",
       "3740876                       0.0                     0   \n",
       "1939891                       0.0                     0   \n",
       "2220721                       0.0                     0   \n",
       "2082256                       0.0                     0   \n",
       "659845                        0.0                     0   \n",
       "1529514                       0.0                     0   \n",
       "2842088                       0.0                     0   \n",
       "2778564                       0.0                     0   \n",
       "2781639                       0.0                     0   \n",
       "2929619                       0.0                     0   \n",
       "1328496                       0.0                     0   \n",
       "1593289                       0.0                     0   \n",
       "399970                        0.0                     0   \n",
       "361924                        0.0                     0   \n",
       "2765223                       0.0                     0   \n",
       "1544165                       0.0                     0   \n",
       "2817400                       0.0                     0   \n",
       "2947083                       0.0                     0   \n",
       "2640655                       0.0                     0   \n",
       "1166377                       0.0                     0   \n",
       "3770481                       0.0                     0   \n",
       "1805873                       0.0                     0   \n",
       "1327302                       0.0                     0   \n",
       "2530601                       0.0                     0   \n",
       "1851028                       0.0                     0   \n",
       "497028                        0.0                     0   \n",
       "1767484                       0.0                     0   \n",
       "1327044                       0.0                     0   \n",
       "1783057                       0.0                     0   \n",
       "3262270                       0.0                     0   \n",
       "188764                        0.0                     0   \n",
       "3273050                       0.0                     0   \n",
       "60571                         0.0                     0   \n",
       "2478167                       0.0                     0   \n",
       "2674072                       0.0                     0   \n",
       "2605975                       0.0                     0   \n",
       "1075227                       0.0                     0   \n",
       "3753935                       0.0                     0   \n",
       "2557160                       0.0                     0   \n",
       "3417094                       0.0                     0   \n",
       "...                           ...                   ...   \n",
       "1305027                       3.0                     4   \n",
       "510795                        3.0                     4   \n",
       "2173177                       3.0                     5   \n",
       "3300048                       1.0                     3   \n",
       "3064480                       1.0                     1   \n",
       "213826                        1.0                     1   \n",
       "2616152                       1.0                     1   \n",
       "1006764                       1.0                     2   \n",
       "2189647                       1.0                     2   \n",
       "307249                        1.0                     2   \n",
       "1575132                       2.0                     2   \n",
       "3657035                       2.0                     2   \n",
       "1384466                       1.0                     1   \n",
       "1584513                       1.0                     1   \n",
       "2286973                       1.0                     1   \n",
       "1866481                       3.0                     4   \n",
       "1852909                       1.0                     6   \n",
       "1703917                       2.0                     2   \n",
       "2648540                       0.0                     3   \n",
       "2171712                       3.0                     4   \n",
       "1246887                       3.0                     6   \n",
       "1880626                       7.0                    15   \n",
       "384299                        6.0                    14   \n",
       "2653179                      10.0                    15   \n",
       "285525                        2.0                     3   \n",
       "2214305                       0.0                     0   \n",
       "1147443                       2.0                     2   \n",
       "395487                        4.0                     4   \n",
       "1780746                       3.0                     3   \n",
       "1834098                       2.0                     2   \n",
       "1685821                       0.0                     0   \n",
       "614221                        0.0                     0   \n",
       "3240967                       0.0                     0   \n",
       "182013                        0.0                     0   \n",
       "3217554                       0.0                     0   \n",
       "559498                        5.0                     5   \n",
       "3629323                       4.0                     4   \n",
       "3763686                       0.0                     0   \n",
       "3446494                       2.0                     2   \n",
       "1800298                       NaN                     0   \n",
       "1292702                       NaN                     0   \n",
       "1003624                       NaN                     0   \n",
       "956496                        NaN                     0   \n",
       "2182853                       NaN                     0   \n",
       "2306198                       NaN                     0   \n",
       "3807364                       NaN                     0   \n",
       "3298174                       NaN                     0   \n",
       "2540885                       NaN                     0   \n",
       "2622366                       NaN                     0   \n",
       "\n",
       "         CNT_DRAWINGS_OTHER_CURRENT  CNT_DRAWINGS_POS_CURRENT  \\\n",
       "2937973                         0.0                       0.0   \n",
       "1296858                         0.0                       0.0   \n",
       "480042                          0.0                       0.0   \n",
       "410641                          0.0                       0.0   \n",
       "3664165                         0.0                       0.0   \n",
       "778938                          0.0                       0.0   \n",
       "1790527                         0.0                       0.0   \n",
       "823874                          0.0                       0.0   \n",
       "564185                          0.0                       0.0   \n",
       "3740876                         0.0                       0.0   \n",
       "1939891                         0.0                       0.0   \n",
       "2220721                         0.0                       0.0   \n",
       "2082256                         0.0                       0.0   \n",
       "659845                          0.0                       0.0   \n",
       "1529514                         0.0                       0.0   \n",
       "2842088                         0.0                       0.0   \n",
       "2778564                         0.0                       0.0   \n",
       "2781639                         0.0                       0.0   \n",
       "2929619                         0.0                       0.0   \n",
       "1328496                         0.0                       0.0   \n",
       "1593289                         0.0                       0.0   \n",
       "399970                          0.0                       0.0   \n",
       "361924                          0.0                       0.0   \n",
       "2765223                         0.0                       0.0   \n",
       "1544165                         0.0                       0.0   \n",
       "2817400                         0.0                       0.0   \n",
       "2947083                         0.0                       0.0   \n",
       "2640655                         0.0                       0.0   \n",
       "1166377                         0.0                       0.0   \n",
       "3770481                         0.0                       0.0   \n",
       "1805873                         0.0                       0.0   \n",
       "1327302                         0.0                       0.0   \n",
       "2530601                         0.0                       0.0   \n",
       "1851028                         0.0                       0.0   \n",
       "497028                          0.0                       0.0   \n",
       "1767484                         0.0                       0.0   \n",
       "1327044                         0.0                       0.0   \n",
       "1783057                         0.0                       0.0   \n",
       "3262270                         0.0                       0.0   \n",
       "188764                          0.0                       0.0   \n",
       "3273050                         0.0                       0.0   \n",
       "60571                           0.0                       0.0   \n",
       "2478167                         0.0                       0.0   \n",
       "2674072                         0.0                       0.0   \n",
       "2605975                         0.0                       0.0   \n",
       "1075227                         0.0                       0.0   \n",
       "3753935                         0.0                       0.0   \n",
       "2557160                         0.0                       0.0   \n",
       "3417094                         0.0                       0.0   \n",
       "...                             ...                       ...   \n",
       "1305027                         0.0                       1.0   \n",
       "510795                          0.0                       1.0   \n",
       "2173177                         0.0                       2.0   \n",
       "3300048                         0.0                       2.0   \n",
       "3064480                         0.0                       0.0   \n",
       "213826                          0.0                       0.0   \n",
       "2616152                         0.0                       0.0   \n",
       "1006764                         0.0                       1.0   \n",
       "2189647                         0.0                       1.0   \n",
       "307249                          0.0                       1.0   \n",
       "1575132                         0.0                       0.0   \n",
       "3657035                         0.0                       0.0   \n",
       "1384466                         0.0                       0.0   \n",
       "1584513                         0.0                       0.0   \n",
       "2286973                         0.0                       0.0   \n",
       "1866481                         0.0                       1.0   \n",
       "1852909                         0.0                       5.0   \n",
       "1703917                         0.0                       0.0   \n",
       "2648540                         0.0                       3.0   \n",
       "2171712                         0.0                       1.0   \n",
       "1246887                         0.0                       3.0   \n",
       "1880626                         0.0                       8.0   \n",
       "384299                          0.0                       8.0   \n",
       "2653179                         0.0                       5.0   \n",
       "285525                          0.0                       1.0   \n",
       "2214305                         0.0                       0.0   \n",
       "1147443                         0.0                       0.0   \n",
       "395487                          0.0                       0.0   \n",
       "1780746                         0.0                       0.0   \n",
       "1834098                         0.0                       0.0   \n",
       "1685821                         0.0                       0.0   \n",
       "614221                          0.0                       0.0   \n",
       "3240967                         0.0                       0.0   \n",
       "182013                          0.0                       0.0   \n",
       "3217554                         0.0                       0.0   \n",
       "559498                          0.0                       0.0   \n",
       "3629323                         0.0                       0.0   \n",
       "3763686                         0.0                       0.0   \n",
       "3446494                         0.0                       0.0   \n",
       "1800298                         NaN                       NaN   \n",
       "1292702                         NaN                       NaN   \n",
       "1003624                         NaN                       NaN   \n",
       "956496                          NaN                       NaN   \n",
       "2182853                         NaN                       NaN   \n",
       "2306198                         NaN                       NaN   \n",
       "3807364                         NaN                       NaN   \n",
       "3298174                         NaN                       NaN   \n",
       "2540885                         NaN                       NaN   \n",
       "2622366                         NaN                       NaN   \n",
       "\n",
       "         CNT_INSTALMENT_MATURE_CUM NAME_CONTRACT_STATUS  SK_DPD  SK_DPD_DEF  \n",
       "2937973                       10.0               Active       0           0  \n",
       "1296858                       10.0               Active       0           0  \n",
       "480042                        10.0               Active       0           0  \n",
       "410641                        10.0               Active       0           0  \n",
       "3664165                       10.0               Active       0           0  \n",
       "778938                        10.0               Active       0           0  \n",
       "1790527                       10.0               Active       0           0  \n",
       "823874                        10.0               Active       0           0  \n",
       "564185                        10.0               Active       0           0  \n",
       "3740876                       10.0               Active       0           0  \n",
       "1939891                       10.0               Active       0           0  \n",
       "2220721                       10.0               Active       0           0  \n",
       "2082256                       10.0               Active       0           0  \n",
       "659845                        10.0               Active       0           0  \n",
       "1529514                       10.0               Active       0           0  \n",
       "2842088                       10.0               Active       0           0  \n",
       "2778564                       10.0               Active       0           0  \n",
       "2781639                       10.0               Active       0           0  \n",
       "2929619                       10.0               Active       0           0  \n",
       "1328496                       10.0               Active       0           0  \n",
       "1593289                       10.0               Active       0           0  \n",
       "399970                        10.0               Active       0           0  \n",
       "361924                        10.0               Active       0           0  \n",
       "2765223                       10.0               Active       0           0  \n",
       "1544165                       10.0               Active       0           0  \n",
       "2817400                       10.0               Active       0           0  \n",
       "2947083                       10.0               Active       0           0  \n",
       "2640655                       10.0               Active       0           0  \n",
       "1166377                       10.0               Active       0           0  \n",
       "3770481                       10.0               Active       0           0  \n",
       "1805873                       10.0               Active       0           0  \n",
       "1327302                       10.0               Active       0           0  \n",
       "2530601                       10.0               Active       0           0  \n",
       "1851028                       10.0               Active       0           0  \n",
       "497028                        10.0               Active       0           0  \n",
       "1767484                       10.0               Active       0           0  \n",
       "1327044                       10.0               Active       0           0  \n",
       "1783057                       10.0               Active       0           0  \n",
       "3262270                       10.0               Active       0           0  \n",
       "188764                        10.0               Active       0           0  \n",
       "3273050                       10.0               Active       0           0  \n",
       "60571                         10.0               Active       0           0  \n",
       "2478167                       10.0               Active       0           0  \n",
       "2674072                       10.0               Active       0           0  \n",
       "2605975                       10.0               Active       0           0  \n",
       "1075227                       10.0               Active       0           0  \n",
       "3753935                       10.0               Active       0           0  \n",
       "2557160                       10.0               Active       0           0  \n",
       "3417094                       10.0               Active       0           0  \n",
       "...                            ...                  ...     ...         ...  \n",
       "1305027                       23.0               Active       0           0  \n",
       "510795                        22.0               Active       0           0  \n",
       "2173177                       21.0               Active       0           0  \n",
       "3300048                       20.0               Active       0           0  \n",
       "3064480                       19.0               Active       0           0  \n",
       "213826                        18.0               Active       0           0  \n",
       "2616152                       17.0               Active       0           0  \n",
       "1006764                       16.0               Active       0           0  \n",
       "2189647                       15.0               Active       0           0  \n",
       "307249                        14.0               Active       0           0  \n",
       "1575132                       13.0               Active       0           0  \n",
       "3657035                       12.0               Active       0           0  \n",
       "1384466                       11.0               Active       0           0  \n",
       "1584513                       10.0               Active       0           0  \n",
       "2286973                        9.0               Active       0           0  \n",
       "1866481                        8.0               Active       0           0  \n",
       "1852909                        7.0               Active       0           0  \n",
       "1703917                        6.0               Active       0           0  \n",
       "2648540                        5.0               Active       0           0  \n",
       "2171712                        4.0               Active       0           0  \n",
       "1246887                        3.0               Active       0           0  \n",
       "1880626                        2.0               Active       0           0  \n",
       "384299                         1.0               Active       0           0  \n",
       "2653179                        NaN               Active       0           0  \n",
       "285525                         NaN               Active       0           0  \n",
       "2214305                       10.0               Active       0           0  \n",
       "1147443                        9.0               Active       0           0  \n",
       "395487                         8.0               Active       0           0  \n",
       "1780746                        7.0               Active       0           0  \n",
       "1834098                        6.0               Active       0           0  \n",
       "1685821                        6.0               Active       0           0  \n",
       "614221                         6.0               Active       0           0  \n",
       "3240967                        6.0               Active       0           0  \n",
       "182013                         6.0               Active       0           0  \n",
       "3217554                        5.0               Active       0           0  \n",
       "559498                         4.0               Active       0           0  \n",
       "3629323                        3.0               Active       0           0  \n",
       "3763686                        2.0               Active       0           0  \n",
       "3446494                        1.0               Active       0           0  \n",
       "1800298                        0.0               Active       0           0  \n",
       "1292702                        0.0               Active       0           0  \n",
       "1003624                        0.0               Active       0           0  \n",
       "956496                         0.0               Active       0           0  \n",
       "2182853                        0.0               Active       0           0  \n",
       "2306198                        0.0               Active       0           0  \n",
       "3807364                        0.0               Active       0           0  \n",
       "3298174                        0.0               Active       0           0  \n",
       "2540885                        0.0               Active       0           0  \n",
       "2622366                        0.0               Active       0           0  \n",
       "\n",
       "[583 rows x 23 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp = df[df.SK_ID_CURR.isin(np.random.choice(ids, size=9))]\n",
    "tmp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp.to_csv('sample_cre.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
